Obtained .csv data from ‘https://github.com/gavinr/usa-soccer’ and removed unnecessary data. Added total championships for each team, data from ‘https://www.goal.com/en-us/news/mls-cup-all-winners-list/blt15fd45904a53e495’.
Create a map of mls teams and number of championships won
Determine the top 2 clubs based on number of championships and create a subset table
## team longitude latitude championships
## 13 LA Galaxy -118.26100 33.86400 5
## 8 D.C. United -77.01287 38.86841 4
## 7 Columbus Crew -83.01709 39.96846 2
## 11 Houston Dynamo FC -95.35240 29.75220 2
## 24 San Jose Earthquakes -121.92500 37.35139 2
## 25 Seattle Sounders FC -122.33160 47.59520 2
## 26 Sporting Kansas City -94.82100 39.12140 2
## 1 Atlanta United FC -84.40000 33.75556 1
## 5 Chicago Fire FC -87.61670 41.86230 1
## 6 Colorado Rapids -104.89194 39.80556 1
## 14 Los Angeles FC -118.28500 34.01300 1
## 18 New York City FC -73.92639 40.82917 1
## 22 Portland Timbers -122.69167 45.52139 1
## 23 Real Salt Lake -111.89340 40.58290 1
## 28 Toronto FC -79.41861 43.63278 1
## 2 Austin FC -97.71984 30.38821 0
## 3 CF Montreal -73.55250 45.56306 0
## 4 Charlotte FC -80.85278 35.22583 0
## 9 FC Cincinnati -84.52222 39.11139 0
## 10 FC Dallas -96.83528 33.15444 0
## 12 Inter Miami CF -80.16111 26.19306 0
## 15 Minnesota United FC -93.16500 44.95278 0
## 16 Nashville SC -86.76556 36.13028 0
## 17 New England Revolution -71.26400 42.09100 0
## 19 New York Red Bulls -74.15028 40.73667 0
## 20 Orlando City SC -81.38930 28.54110 0
## 21 Philadelphia Union -75.37889 39.83222 0
## 27 St. Louis City SC -90.21092 38.63103 0
## 29 Vancouver Whitecaps FC -123.11194 49.27667 0
It was determined that LA Galaxy and DC United have the most championships with 6 and 5, respectfully. Its to be noted that although they have significantly more titles, the next closest teams with 2, they have were in the MLS since it was founded in 1996
Obtained average attendance records for the 2021 season from ‘https://www.worldfootball.net/attendance/usa-major-league-soccer-2021/3/’, placed the data in a .csv and imported it.
## ï..Team Average.Attendance Stadium.Capacity
## 17 New York City FC 10,932 30,321
## 26 Toronto FC 10,442 28,351
## 18 New York Red Bulls 12,558 25,000
## 4 Chicago Fire 13,160 24,995
## 13 Los Angeles Galaxy 14,580 27,000
## 24 Seattle Sounders 20,443 37,722
## 3 CF Montreal 10,831 19,619
## 27 Vancouver Whitecaps 12,315 22,120
## 19 Orlando City 14,489 25,500
## 21 Portland Timbers 15,120 25,218
## 10 Houston Dynamo 13,517 22,039
## 15 Nashville SC 18,326 30,000
## 8 FC Cincinnati 16,644 26,000
## 7 D.C. United 12,919 20,000
## 5 Colorado Rapids 12,291 18,061
## 16 New England Revolution 13,579 20,000
## 1 Atlanta United FC 29,899 42,500
## 20 Philadelphia Union 13,069 18,500
## 9 FC Dallas 14,034 19,096
## 23 San Jose Earthquakes 13,317 18,000
## 14 Minnesota United FC 14,533 19,400
## 2 Austin FC 16,019 20,738
## 22 Real Salt Lake 15,643 20,213
## 6 Columbus Crew 16,315 20,371
## 25 Sporting Kansas City 14,756 18,467
## 11 Inter Miami CF 15,828 18,000
## 12 Los Angeles FC 19,439 22,000
## Attendance.Percent
## 17 0.36
## 26 0.37
## 18 0.50
## 4 0.53
## 13 0.54
## 24 0.54
## 3 0.55
## 27 0.56
## 19 0.57
## 21 0.60
## 10 0.61
## 15 0.61
## 8 0.64
## 7 0.65
## 5 0.68
## 16 0.68
## 1 0.70
## 20 0.71
## 9 0.73
## 23 0.74
## 14 0.75
## 2 0.77
## 22 0.77
## 6 0.80
## 25 0.80
## 11 0.88
## 12 0.88
New York City FC has the lowest attendance average, only filling 36 percent of their stadium. Los Angeles FC on average fills 88 percent of their stadium.
Pull 2021 acs census data for Washington DC and Los Angeles to analyze demographics of the two most successful teams in mls history.
## Getting data from the 2017-2021 5-year ACS
## Getting data from the 2017-2021 5-year ACS
## Getting data from the 2017-2021 5-year ACS
## Getting data from the 2017-2021 5-year ACS
Pull 2021 acs census data for New York to analyze demographics in comparison to attendance averages and mhhi.
## Getting data from the 2017-2021 5-year ACS
## Getting data from the 2017-2021 5-year ACS
Plot demographics to compare median income and percent Hispanic
Created plots to find correlations between percent Hispanic Population and median household income.
## `geom_smooth()` using formula = 'y ~ x'
## `geom_smooth()` using formula = 'y ~ x'
## `geom_smooth()` using formula = 'y ~ x'
## [1] 0.1378796
## [1] -0.5074496
## [1] -0.2770464